home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Wayzata's Best of Shareware PC/Windows 1
/
Wayzata's Best of Shareware for PC-Windows - Release 1 - Wayzata Technology (1993).iso
/
mac
/
WINDOWS
/
DATABASE
/
ADDBK
/
ADDBOOK.TXT
< prev
next >
Wrap
Text File
|
1992-12-23
|
2KB
|
41 lines
ADDBOOK.MDB is a business and personal address book database
with two main tables (Company Addresses and Personal Addresses)
and three small related tables containing Business Category,
Hardware and Software Information. An AutoExec macro offers
you a choice of the Business or Personal data entry form, and
you can switch between forms with buttons. A Contacts query
selects persons from the Personal Addresses table who have an
entry for ID, and displays them on a Contacts form (you can
switch from this form to the Personal Addresses form if you
want to see the contact's home address).
There are several reports for letter-sized paper, two mailing
labels reports (Avery #5160 and #5161) and also rolodex reports
which print on Avery #5385 laser rolodex cards.
The forms feature command buttons for applying filters, a
record selector combo box (which picks up the form's filter, if
any), automatic formatting of phone numbers, pseudo-embedded
labels, and pop-up hardware and software forms (the buttons for
these forms are only enabled for companies in the Computer
category). They were designed for high-resolution displays
(the labels in the "embedded label" controls are in 6 pt type).
The reports illustrate extensive use of Iif functions to
prevent blank rows, and the rolodex reports have embedded
graphics (HiJaak/Win OLE object).
A BatchExport macro creates dBASE tables by means of several
make-table queries. These tables can be used to create YourWay
3.0 cardfiles, using the enclosed YWCARDS.WBT (a Norton Desktop
Batch Runner batch file), or used to import into any program
that uses dBASE databases. (Starter .DBF and .YDB files are
included in the zip file.) Before using this macro or batch
file, change the path names to match your computer setup.
This database was designed by Helen Feddema, author of Inside
Microsoft Access (New Riders Publishing), and contributor to
Access Advisor and Smart Access magazines.